Excel中 if, and , other函数问题答:公式如下:=if(and(B="及格",or(A="语文",A="数学"),"合格",if(and(B="不及格",or(A="语文",A="数学"),"补考",B))
EXCEL函数中,IF,AND和OR函数的用法答:首先,公式有些地方画蛇添足,可以优化为:=IF(B4="磨头一班",IF(BP4<=0.006,100,IF(BP4<=0.007,50,0)),IF(BP4<=0.003,100,IF(BP4<=0.004,50,0)))解释如下:假如B4单元格为“磨头一班”:当BP4小于等于0.006时,显示100;当BP4大于0.006且小于等于0.007时,显示50;当BP4...
excel中if函数中逻辑函数 或和且 分别怎么用的答:都大于60为合格 =if(min(a1:f1)>=60,"合格","不合格")或 =IF(AND(A1>=60,B1>=60,C1>=60,D1>=60 ,F1>=60),“合格","不合格")只要有门达60为合格 =if(max(a1:f1)>=60,"合格","不合格")或 =IF(OR(A1>=60,B1>=60,C1>=60,D1>=60 ,F1>=60),“合格","不合格")...